Pandas Profiling Report

Dataset statistics

Number of variables	18
Number of observations	24078
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	3.3 MiB
Average record size in memory	144.0 B

Variable types

Numeric	10
Categorical	8

Alerts

`Attempted` is highly overall correlated with `Full`	High correlation
`NumberOfMajors` is highly overall correlated with `NumberOfUniqueMajors`	High correlation
`NumberOfUniqueMajors` is highly overall correlated with `NumberOfMajors`	High correlation
`Full` is highly overall correlated with `Attempted`	High correlation
`Ethnicity` is highly overall correlated with `IsHispanic`	High correlation
`IsHispanic` is highly overall correlated with `Ethnicity`	High correlation
`Dev` is highly imbalanced (75.6%)	Imbalance
`Ethnicity` is highly imbalanced (54.7%)	Imbalance
`IsHispanic` is highly imbalanced (60.5%)	Imbalance
`Internet` has 11642 (48.4%) zeros	Zeros
`PercentageOfRepeats` has 20092 (83.4%) zeros	Zeros
`PercentageOfHistDrop` has 16928 (70.3%) zeros	Zeros
`CumGPALast` has 370 (1.5%) zeros	Zeros
`PercentageOfAbsence` has 8873 (36.9%) zeros	Zeros

Reproduction

Analysis started	2023-05-18 19:02:21.353741
Analysis finished	2023-05-18 19:02:57.358801
Duration	36.01 seconds
Software version	pandas-profiling v3.6.6
Download configuration	config.json

StudentID
Real number (ℝ)

Distinct	11440
Distinct (%)	47.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	6.375135 × 10⁹

Minimum	1.0100118 × 10⁸
Maximum	1.0112752 × 10¹⁰
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	188.2 KiB

Quantile statistics

Minimum	1.0100118 × 10⁸
5-th percentile	1.9500906 × 10⁸
Q1	5.5600459 × 10⁸
median	1.0111105 × 10¹⁰
Q3	1.0111117 × 10¹⁰
95-th percentile	1.011274 × 10¹⁰
Maximum	1.0112752 × 10¹⁰
Range	1.0011751 × 10¹⁰
Interquartile range (IQR)	9.5551128 × 10⁹

Descriptive statistics

Standard deviation	4.7022347 × 10⁹
Coefficient of variation (CV)	0.73758983
Kurtosis	-1.780313
Mean	6.375135 × 10⁹
Median Absolute Deviation (MAD)	1630342
Skewness	-0.46538127
Sum	1.535005 × 10¹⁴
Variance	2.2111012 × 10¹⁹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1.011110424 × 10¹⁰	11	< 0.1%
1.011110321 × 10¹⁰	10	< 0.1%
673006251	10	< 0.1%
396009807	10	< 0.1%
1.011110503 × 10¹⁰	9	< 0.1%
414008883	9	< 0.1%
1.011110491 × 10¹⁰	9	< 0.1%
712001867	9	< 0.1%
716002765	9	< 0.1%
252003703	9	< 0.1%
Other values (11430)	23983	99.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
101001184	2	< 0.1%
101003030	3	< 0.1%
101004016	1	< 0.1%
101009897	3	< 0.1%
102001082	1	< 0.1%
102002426	2	< 0.1%
102002757	4	< 0.1%
102004142	2	< 0.1%
102007458	1	< 0.1%
102008114	5	< 0.1%

Value	Count	Frequency (%)
1.011275214 × 10¹⁰	1	< 0.1%
1.011275214 × 10¹⁰	1	< 0.1%
1.01127521 × 10¹⁰	1	< 0.1%
1.011275208 × 10¹⁰	1	< 0.1%
1.011275207 × 10¹⁰	1	< 0.1%
1.011275207 × 10¹⁰	1	< 0.1%
1.011275203 × 10¹⁰	1	< 0.1%
1.011275201 × 10¹⁰	1	< 0.1%
1.011275201 × 10¹⁰	1	< 0.1%
1.011275201 × 10¹⁰	1	< 0.1%

Attempted
Real number (ℝ)

Distinct	26
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	9.2604868

Minimum	1
Maximum	26
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	188.2 KiB

Quantile statistics

Minimum	1
5-th percentile	3
Q1	6
median	9
Q3	13
95-th percentile	16
Maximum	26
Range	25
Interquartile range (IQR)	7

Descriptive statistics

Standard deviation	4.1064977
Coefficient of variation (CV)	0.44344296
Kurtosis	-0.42455466
Mean	9.2604868
Median Absolute Deviation (MAD)	3
Skewness	0.35569483
Sum	222974
Variance	16.863323
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=26)

Value	Count	Frequency (%)
6	3608	15.0%
8	2592	10.8%
13	2468	10.3%
3	2370	9.8%
9	2360	9.8%
12	2112	8.8%
10	1527	6.3%
7	1455	6.0%
4	1205	5.0%
14	914	3.8%
Other values (16)	3467	14.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	18	0.1%
2	42	0.2%
3	2370	9.8%
4	1205	5.0%
5	101	0.4%
6	3608	15.0%
7	1455	6.0%
8	2592	10.8%
9	2360	9.8%
10	1527	6.3%

Value	Count	Frequency (%)
26	1	< 0.1%
25	7	< 0.1%
24	4	< 0.1%
23	21	0.1%
22	23	0.1%
21	58	0.2%
20	53	0.2%
19	314	1.3%
18	166	0.7%
17	251	1.0%

Full
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	188.2 KiB

0	17050
1	7028

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	24078
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1
2nd row	0
3rd row	1
4th row	1
5th row	1

Common Values

Value	Count	Frequency (%)
0	17050	70.8%
1	7028	29.2%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	17050	70.8%
1	7028	29.2%

Most occurring characters

Value	Count	Frequency (%)
0	17050	70.8%
1	7028	29.2%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	24078	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	17050	70.8%
1	7028	29.2%

Most occurring scripts

Value	Count	Frequency (%)
Common	24078	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	17050	70.8%
1	7028	29.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	24078	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	17050	70.8%
1	7028	29.2%

Age
Real number (ℝ)

Distinct	58
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	23.934255

Minimum	14
Maximum	75
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	188.2 KiB

Quantile statistics

Minimum	14
5-th percentile	17
Q1	18
median	20
Q3	26
95-th percentile	43
Maximum	75
Range	61
Interquartile range (IQR)	8

Descriptive statistics

Standard deviation	8.676219
Coefficient of variation (CV)	0.36250215
Kurtosis	3.5002275
Mean	23.934255
Median Absolute Deviation (MAD)	2
Skewness	1.8893765
Sum	576289
Variance	75.276776
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
18	3608	15.0%
19	3197	13.3%
20	2505	10.4%
17	2439	10.1%
21	1801	7.5%
22	1193	5.0%
23	912	3.8%
24	717	3.0%
25	616	2.6%
26	540	2.2%
Other values (48)	6550	27.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
14	1	< 0.1%
15	135	0.6%
16	483	2.0%
17	2439	10.1%
18	3608	15.0%
19	3197	13.3%
20	2505	10.4%
21	1801	7.5%
22	1193	5.0%
23	912	3.8%

Value	Count	Frequency (%)
75	1	< 0.1%
70	2	< 0.1%
69	1	< 0.1%
68	4	< 0.1%
67	7	< 0.1%
66	3	< 0.1%
65	10	< 0.1%
64	7	< 0.1%
63	8	< 0.1%
62	21	0.1%

Dev
Categorical

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	188.2 KiB

0	22004
1	1702
2	340
3	32

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	24078
Distinct characters	4
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	1
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	22004	91.4%
1	1702	7.1%
2	340	1.4%
3	32	0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	22004	91.4%
1	1702	7.1%
2	340	1.4%
3	32	0.1%

Most occurring characters

Value	Count	Frequency (%)
0	22004	91.4%
1	1702	7.1%
2	340	1.4%
3	32	0.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	24078	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	22004	91.4%
1	1702	7.1%
2	340	1.4%
3	32	0.1%

Most occurring scripts

Value	Count	Frequency (%)
Common	24078	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	22004	91.4%
1	1702	7.1%
2	340	1.4%
3	32	0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	24078	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	22004	91.4%
1	1702	7.1%
2	340	1.4%
3	32	0.1%

Internet
Real number (ℝ)

Distinct	10
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.1032062

Minimum	0
Maximum	9
Zeros	11642
Zeros (%)	48.4%
Negative	0
Negative (%)	0.0%
Memory size	188.2 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	1
Q3	2
95-th percentile	4
Maximum	9
Range	9
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	1.407834
Coefficient of variation (CV)	1.2761295
Kurtosis	1.4645788
Mean	1.1032062
Median Absolute Deviation (MAD)	1
Skewness	1.3628079
Sum	26563
Variance	1.9819966
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
0	11642	48.4%
1	5074	21.1%
2	3528	14.7%
3	1941	8.1%
4	1147	4.8%
5	522	2.2%
6	164	0.7%
7	54	0.2%
8	4	< 0.1%
9	2	< 0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	11642	48.4%
1	5074	21.1%
2	3528	14.7%
3	1941	8.1%
4	1147	4.8%
5	522	2.2%
6	164	0.7%
7	54	0.2%
8	4	< 0.1%
9	2	< 0.1%

Value	Count	Frequency (%)
9	2	< 0.1%
8	4	< 0.1%
7	54	0.2%
6	164	0.7%
5	522	2.2%
4	1147	4.8%
3	1941	8.1%
2	3528	14.7%
1	5074	21.1%
0	11642	48.4%

PercentageOfRepeats
Real number (ℝ)

Distinct	37
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.091595636

Minimum	0
Maximum	1
Zeros	20092
Zeros (%)	83.4%
Negative	0
Negative (%)	0.0%
Memory size	188.2 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0.71428571
Maximum	1
Range	1
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.2391691
Coefficient of variation (CV)	2.6111408
Kurtosis	6.7928142
Mean	0.091595636
Median Absolute Deviation (MAD)	0
Skewness	2.776851
Sum	2205.4397
Variance	0.057201859
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=37)

Value	Count	Frequency (%)
0	20092	83.4%
1	951	3.9%
0.5	547	2.3%
0.25	426	1.8%
0.3333333333	415	1.7%
0.2	371	1.5%
0.6666666667	293	1.2%
0.4	261	1.1%
0.1666666667	154	0.6%
0.75	125	0.5%
Other values (27)	443	1.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	20092	83.4%
0.09090909091	1	< 0.1%
0.1	1	< 0.1%
0.1111111111	1	< 0.1%
0.125	14	0.1%
0.1428571429	42	0.2%
0.1666666667	154	0.6%
0.2	371	1.5%
0.2222222222	8	< 0.1%
0.25	426	1.8%

Value	Count	Frequency (%)
1	951	3.9%
0.9	1	< 0.1%
0.8888888889	3	< 0.1%
0.875	7	< 0.1%
0.8571428571	15	0.1%
0.8333333333	23	0.1%
0.8	66	0.3%
0.7777777778	2	< 0.1%
0.75	125	0.5%
0.7272727273	2	< 0.1%

PercentageOfHistDrop
Real number (ℝ)

Distinct	302
Distinct (%)	1.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.055235649

Minimum	0
Maximum	1
Zeros	16928
Zeros (%)	70.3%
Negative	0
Negative (%)	0.0%
Memory size	188.2 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0.058823529
95-th percentile	0.28571429
Maximum	1
Range	1
Interquartile range (IQR)	0.058823529

Descriptive statistics

Standard deviation	0.12639639
Coefficient of variation (CV)	2.2883119
Kurtosis	20.678625
Mean	0.055235649
Median Absolute Deviation (MAD)	0
Skewness	3.9113459
Sum	1329.964
Variance	0.015976048
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	16928	70.3%
0.2	358	1.5%
0.25	325	1.3%
0.1666666667	269	1.1%
0.3333333333	261	1.1%
0.1428571429	256	1.1%
0.1111111111	243	1.0%
0.125	239	1.0%
0.5	223	0.9%
0.1	203	0.8%
Other values (292)	4773	19.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	16928	70.3%
0.01754385965	2	< 0.1%
0.01886792453	1	< 0.1%
0.01923076923	1	< 0.1%
0.01960784314	1	< 0.1%
0.02	3	< 0.1%
0.02040816327	3	< 0.1%
0.02083333333	3	< 0.1%
0.02127659574	3	< 0.1%
0.02173913043	3	< 0.1%

Value	Count	Frequency (%)
1	144	0.6%
0.8333333333	2	< 0.1%
0.8	4	< 0.1%
0.75	10	< 0.1%
0.7142857143	2	< 0.1%
0.7	1	< 0.1%
0.6666666667	33	0.1%
0.6363636364	1	< 0.1%
0.625	3	< 0.1%
0.6153846154	2	< 0.1%

TermCode
Categorical

Distinct	13
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	188.2 KiB

B17C	3221
B18C	3138
B17Q	2551
B19C	2079
B23C	1962
Other values (8)	11127

Length

Max length	4
Median length	4
Mean length	4
Min length	4

Characters and Unicode

Total characters	96312
Distinct characters	10
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	B17C
2nd row	B18Q
3rd row	B17C
4th row	B17C
5th row	B19Q

Common Values

Value	Count	Frequency (%)
B17C	3221	13.4%
B18C	3138	13.0%
B17Q	2551	10.6%
B19C	2079	8.6%
B23C	1962	8.1%
B21C	1843	7.7%
B22C	1704	7.1%
B19Q	1611	6.7%
B18Q	1584	6.6%
B22Q	1412	5.9%
Other values (3)	2973	12.3%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
b17c	3221	13.4%
b18c	3138	13.0%
b17q	2551	10.6%
b19c	2079	8.6%
b23c	1962	8.1%
b21c	1843	7.7%
b22c	1704	7.1%
b19q	1611	6.7%
b18q	1584	6.6%
b22q	1412	5.9%
Other values (3)	2973	12.3%

Most occurring characters

Value	Count	Frequency (%)
B	24078	25.0%
1	17412	18.1%
C	14141	14.7%
2	13010	13.5%
Q	9937	10.3%
7	5772	6.0%
8	4722	4.9%
9	3690	3.8%
3	1962	2.0%
0	1588	1.6%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	48156	50.0%
Decimal Number	48156	50.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	17412	36.2%
2	13010	27.0%
7	5772	12.0%
8	4722	9.8%
9	3690	7.7%
3	1962	4.1%
0	1588	3.3%

Uppercase Letter

Value	Count	Frequency (%)
B	24078	50.0%
C	14141	29.4%
Q	9937	20.6%

Most occurring scripts

Value	Count	Frequency (%)
Latin	48156	50.0%
Common	48156	50.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
1	17412	36.2%
2	13010	27.0%
7	5772	12.0%
8	4722	9.8%
9	3690	7.7%
3	1962	4.1%
0	1588	3.3%

Latin

Value	Count	Frequency (%)
B	24078	50.0%
C	14141	29.4%
Q	9937	20.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	96312	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
B	24078	25.0%
1	17412	18.1%
C	14141	14.7%
2	13010	13.5%
Q	9937	10.3%
7	5772	6.0%
8	4722	4.9%
9	3690	3.8%
3	1962	2.0%
0	1588	1.6%

MajorChangedFromLast
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	188.2 KiB

0	20861
1	3217

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	24078
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	1
3rd row	0
4th row	1
5th row	0

Common Values

Value	Count	Frequency (%)
0	20861	86.6%
1	3217	13.4%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	20861	86.6%
1	3217	13.4%

Most occurring characters

Value	Count	Frequency (%)
0	20861	86.6%
1	3217	13.4%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	24078	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	20861	86.6%
1	3217	13.4%

Most occurring scripts

Value	Count	Frequency (%)
Common	24078	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	20861	86.6%
1	3217	13.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	24078	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	20861	86.6%
1	3217	13.4%

NumberOfMajors
Real number (ℝ)

Distinct	27
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	5.5774981

Minimum	1
Maximum	36
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	188.2 KiB

Quantile statistics

Minimum	1
5-th percentile	2
Q1	3
median	5
Q3	7
95-th percentile	12
Maximum	36
Range	35
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	3.3878038
Coefficient of variation (CV)	0.60740563
Kurtosis	2.4495501
Mean	5.5774981
Median Absolute Deviation (MAD)	2
Skewness	1.3895451
Sum	134295
Variance	11.477214
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=27)

Value	Count	Frequency (%)
4	4060	16.9%
2	3877	16.1%
3	3439	14.3%
5	2964	12.3%
6	2169	9.0%
7	1805	7.5%
8	1454	6.0%
9	1002	4.2%
10	908	3.8%
11	653	2.7%
Other values (17)	1747	7.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	171	0.7%
2	3877	16.1%
3	3439	14.3%
4	4060	16.9%
5	2964	12.3%
6	2169	9.0%
7	1805	7.5%
8	1454	6.0%
9	1002	4.2%
10	908	3.8%

Value	Count	Frequency (%)
36	1	< 0.1%
26	1	< 0.1%
25	3	< 0.1%
24	4	< 0.1%
23	4	< 0.1%
22	14	0.1%
21	17	0.1%
20	26	0.1%
19	44	0.2%
18	50	0.2%

NumberOfUniqueMajors
Real number (ℝ)

Distinct	6
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.5147853

Minimum	1
Maximum	6
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	188.2 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	1
Q3	2
95-th percentile	3
Maximum	6
Range	5
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	0.7413366
Coefficient of variation (CV)	0.48940045
Kurtosis	2.1854944
Mean	1.5147853
Median Absolute Deviation (MAD)	0
Skewness	1.4849018
Sum	36473
Variance	0.54957995
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=6)

Value	Count	Frequency (%)
1	14667	60.9%
2	6977	29.0%
3	1953	8.1%
4	418	1.7%
5	57	0.2%
6	6	< 0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	14667	60.9%
2	6977	29.0%
3	1953	8.1%
4	418	1.7%
5	57	0.2%
6	6	< 0.1%

Value	Count	Frequency (%)
6	6	< 0.1%
5	57	0.2%
4	418	1.7%
3	1953	8.1%
2	6977	29.0%
1	14667	60.9%

CumGPALast
Real number (ℝ)

Distinct	3939
Distinct (%)	16.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3.0147963

Minimum	0
Maximum	4
Zeros	370
Zeros (%)	1.5%
Negative	0
Negative (%)	0.0%
Memory size	188.2 KiB

Quantile statistics

Minimum	0
5-th percentile	1.5
Q1	2.563825
median	3.125
Q3	3.6471
95-th percentile	4
Maximum	4
Range	4
Interquartile range (IQR)	1.083275

Descriptive statistics

Standard deviation	0.83323746
Coefficient of variation (CV)	0.27638267
Kurtosis	1.8044744
Mean	3.0147963
Median Absolute Deviation (MAD)	0.5417
Skewness	-1.1971195
Sum	72590.267
Variance	0.69428467
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
4	3393	14.1%
3	1989	8.3%
3.5	943	3.9%
2	869	3.6%
2.5	555	2.3%
0	370	1.5%
3.25	305	1.3%
3.75	288	1.2%
3.3333	246	1.0%
3.6667	246	1.0%
Other values (3929)	14874	61.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	370	1.5%
0.0909	1	< 0.1%
0.1364	1	< 0.1%
0.1429	3	< 0.1%
0.15	1	< 0.1%
0.1667	1	< 0.1%
0.1765	1	< 0.1%
0.1818	2	< 0.1%
0.1875	1	< 0.1%
0.2	2	< 0.1%

Value	Count	Frequency (%)
4	3393	14.1%
3.9897	1	< 0.1%
3.969	1	< 0.1%
3.9634	1	< 0.1%
3.962	1	< 0.1%
3.961	1	< 0.1%
3.96	1	< 0.1%
3.9592	1	< 0.1%
3.9577	2	< 0.1%
3.9565	1	< 0.1%

PercentageOfAbsence
Real number (ℝ)

Distinct	1373
Distinct (%)	5.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.092939393

Minimum	0
Maximum	1
Zeros	8873
Zeros (%)	36.9%
Negative	0
Negative (%)	0.0%
Memory size	188.2 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0.04
Q3	0.11764706
95-th percentile	0.39655172
Maximum	1
Range	1
Interquartile range (IQR)	0.11764706

Descriptive statistics

Standard deviation	0.14427427
Coefficient of variation (CV)	1.5523479
Kurtosis	8.33012
Mean	0.092939393
Median Absolute Deviation (MAD)	0.04
Skewness	2.6523385
Sum	2237.7947
Variance	0.020815064
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	8873	36.9%
0.1111111111	224	0.9%
0.05882352941	224	0.9%
0.125	209	0.9%
0.05555555556	208	0.9%
0.06666666667	196	0.8%
0.0625	193	0.8%
0.09090909091	191	0.8%
0.1	190	0.8%
0.1666666667	182	0.8%
Other values (1363)	13388	55.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	8873	36.9%
0.007042253521	1	< 0.1%
0.007575757576	1	< 0.1%
0.007751937984	1	< 0.1%
0.008064516129	1	< 0.1%
0.008196721311	1	< 0.1%
0.008474576271	1	< 0.1%
0.008695652174	2	< 0.1%
0.008928571429	2	< 0.1%
0.009259259259	1	< 0.1%

Value	Count	Frequency (%)
1	5	< 0.1%
0.9756097561	1	< 0.1%
0.9736842105	1	< 0.1%
0.9696969697	1	< 0.1%
0.96875	1	< 0.1%
0.9666666667	1	< 0.1%
0.9622641509	1	< 0.1%
0.9615384615	1	< 0.1%
0.96	1	< 0.1%
0.95	3	< 0.1%

Ethnicity
Categorical

HIGH CORRELATION IMBALANCE

Distinct	10
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	188.2 KiB

White, Non-Hispanic	16760
Hispanic	3467
Black, Non-Hispanic	1847
American Indian or Alaskan Native	1107
Asian	472
Other values (5)	425

Length

Max length	35
Median length	19
Mean length	17.754631
Min length	5

Characters and Unicode

Total characters	427496
Distinct characters	32
Distinct categories	5 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	White, Non-Hispanic
2nd row	White, Non-Hispanic
3rd row	White, Non-Hispanic
4th row	Hispanic
5th row	Hispanic

Common Values

Value	Count	Frequency (%)
White, Non-Hispanic	16760	69.6%
Hispanic	3467	14.4%
Black, Non-Hispanic	1847	7.7%
American Indian or Alaskan Native	1107	4.6%
Asian	472	2.0%
Unknown or Not Reported	134	0.6%
International	133	0.6%
unknown	105	0.4%
Native Hawaiian or Pacific Islander	48	0.2%
Not Hispanic or Latino	5	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
non-hispanic	18607	39.0%
white	16760	35.1%
hispanic	3472	7.3%
black	1847	3.9%
or	1294	2.7%
native	1155	2.4%
american	1107	2.3%
indian	1107	2.3%
alaskan	1107	2.3%
asian	472	1.0%
Other values (8)	794	1.7%

Most occurring characters

Value	Count	Frequency (%)
i	65089	15.2%
n	46803	10.9%
a	30492	7.1%
c	25129	5.9%
s	23706	5.5%
	23644	5.5%
p	22213	5.2%
H	22127	5.2%
o	20551	4.8%
N	19901	4.7%
Other values (22)	127841	29.9%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	301708	70.6%
Uppercase Letter	64930	15.2%
Space Separator	23644	5.5%
Dash Punctuation	18607	4.4%
Other Punctuation	18607	4.4%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
i	65089	21.6%
n	46803	15.5%
a	30492	10.1%
c	25129	8.3%
s	23706	7.9%
p	22213	7.4%
o	20551	6.8%
e	19471	6.5%
t	18459	6.1%
h	16760	5.6%
Other values (9)	13035	4.3%

Uppercase Letter

Value	Count	Frequency (%)
H	22127	34.1%
N	19901	30.6%
W	16760	25.8%
A	2686	4.1%
B	1847	2.8%
I	1288	2.0%
U	134	0.2%
R	134	0.2%
P	48	0.1%
L	5	< 0.1%

Space Separator

Value	Count	Frequency (%)
	23644	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	18607	100.0%

Other Punctuation

Value	Count	Frequency (%)
,	18607	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	366638	85.8%
Common	60858	14.2%

Most frequent character per script

Latin

Value	Count	Frequency (%)
i	65089	17.8%
n	46803	12.8%
a	30492	8.3%
c	25129	6.9%
s	23706	6.5%
p	22213	6.1%
H	22127	6.0%
o	20551	5.6%
N	19901	5.4%
e	19471	5.3%
Other values (19)	71156	19.4%

Common

Value	Count	Frequency (%)
	23644	38.9%
-	18607	30.6%
,	18607	30.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	427496	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
i	65089	15.2%
n	46803	10.9%
a	30492	7.1%
c	25129	5.9%
s	23706	5.5%
	23644	5.5%
p	22213	5.2%
H	22127	5.2%
o	20551	4.8%
N	19901	4.7%
Other values (22)	127841	29.9%

Gender
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	188.2 KiB

Female	14889
Male	9173
unknown	16

Length

Max length	7
Median length	6
Mean length	5.2387241
Min length	4

Characters and Unicode

Total characters	126138
Distinct characters	11
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Female
2nd row	Female
3rd row	Female
4th row	Female
5th row	Female

Common Values

Value	Count	Frequency (%)
Female	14889	61.8%
Male	9173	38.1%
unknown	16	0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
female	14889	61.8%
male	9173	38.1%
unknown	16	0.1%

Most occurring characters

Value	Count	Frequency (%)
e	38951	30.9%
a	24062	19.1%
l	24062	19.1%
F	14889	11.8%
m	14889	11.8%
M	9173	7.3%
n	48	< 0.1%
u	16	< 0.1%
k	16	< 0.1%
o	16	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	102076	80.9%
Uppercase Letter	24062	19.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	38951	38.2%
a	24062	23.6%
l	24062	23.6%
m	14889	14.6%
n	48	< 0.1%
u	16	< 0.1%
k	16	< 0.1%
o	16	< 0.1%
w	16	< 0.1%

Uppercase Letter

Value	Count	Frequency (%)
F	14889	61.9%
M	9173	38.1%

Most occurring scripts

Value	Count	Frequency (%)
Latin	126138	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	38951	30.9%
a	24062	19.1%
l	24062	19.1%
F	14889	11.8%
m	14889	11.8%
M	9173	7.3%
n	48	< 0.1%
u	16	< 0.1%
k	16	< 0.1%
o	16	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	126138	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	38951	30.9%
a	24062	19.1%
l	24062	19.1%
F	14889	11.8%
m	14889	11.8%
M	9173	7.3%
n	48	< 0.1%
u	16	< 0.1%
k	16	< 0.1%
o	16	< 0.1%

IsHispanic
Categorical

HIGH CORRELATION IMBALANCE

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	188.2 KiB

No	20514
Yes	3494
unknown	70

Length

Max length	7
Median length	2
Mean length	2.1596478
Min length	2

Characters and Unicode

Total characters	52000
Distinct characters	9
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	No
2nd row	No
3rd row	No
4th row	Yes
5th row	Yes

Common Values

Value	Count	Frequency (%)
No	20514	85.2%
Yes	3494	14.5%
unknown	70	0.3%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
no	20514	85.2%
yes	3494	14.5%
unknown	70	0.3%

Most occurring characters

Value	Count	Frequency (%)
o	20584	39.6%
N	20514	39.5%
Y	3494	6.7%
e	3494	6.7%
s	3494	6.7%
n	210	0.4%
u	70	0.1%
k	70	0.1%
w	70	0.1%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	27992	53.8%
Uppercase Letter	24008	46.2%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
o	20584	73.5%
e	3494	12.5%
s	3494	12.5%
n	210	0.8%
u	70	0.3%
k	70	0.3%
w	70	0.3%

Uppercase Letter

Value	Count	Frequency (%)
N	20514	85.4%
Y	3494	14.6%

Most occurring scripts

Value	Count	Frequency (%)
Latin	52000	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
o	20584	39.6%
N	20514	39.5%
Y	3494	6.7%
e	3494	6.7%
s	3494	6.7%
n	210	0.4%
u	70	0.1%
k	70	0.1%
w	70	0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	52000	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
o	20584	39.6%
N	20514	39.5%
Y	3494	6.7%
e	3494	6.7%
s	3494	6.7%
n	210	0.4%
u	70	0.1%
k	70	0.1%
w	70	0.1%

Target
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	188.2 KiB

0	21163
1	2915

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	24078
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	1
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	21163	87.9%
1	2915	12.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	21163	87.9%
1	2915	12.1%

Most occurring characters

Value	Count	Frequency (%)
0	21163	87.9%
1	2915	12.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	24078	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	21163	87.9%
1	2915	12.1%

Most occurring scripts

Value	Count	Frequency (%)
Common	24078	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	21163	87.9%
1	2915	12.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	24078	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	21163	87.9%
1	2915	12.1%

Auto

Heatmap
Table

	StudentID	Attempted	Age	Internet	PercentageOfRepeats	PercentageOfHistDrop	NumberOfMajors	NumberOfUniqueMajors	CumGPALast	PercentageOfAbsence	Full	Dev	TermCode	MajorChangedFromLast	Ethnicity	Gender	IsHispanic	Target
StudentID	1.000	-0.133	-0.472	0.062	-0.171	-0.280	-0.263	-0.170	0.165	-0.054	0.050	0.007	0.447	0.113	0.066	0.066	0.042	0.017
Attempted	-0.133	1.000	0.265	0.377	0.111	0.099	0.180	0.221	-0.078	0.081	0.901	0.125	0.065	0.159	0.049	0.054	0.026	0.161
Age	-0.472	0.265	1.000	-0.083	0.204	0.292	0.411	0.381	-0.166	0.027	0.083	0.021	0.042	0.126	0.079	0.083	0.085	0.016
Internet	0.062	0.377	-0.083	1.000	0.081	0.037	0.017	-0.011	0.006	0.051	0.372	0.059	0.050	0.034	0.022	0.027	0.000	0.155
PercentageOfRepeats	-0.171	0.111	0.204	0.081	1.000	0.338	0.141	0.076	-0.341	0.260	0.216	0.159	0.044	0.057	0.034	0.017	0.032	0.156
PercentageOfHistDrop	-0.280	0.099	0.292	0.037	0.338	1.000	0.291	0.219	-0.286	0.173	0.029	0.090	0.032	0.084	0.015	0.010	0.006	0.122
NumberOfMajors	-0.263	0.180	0.411	0.017	0.141	0.291	1.000	0.515	-0.049	-0.045	0.104	0.048	0.102	0.108	0.023	0.072	0.040	0.046
NumberOfUniqueMajors	-0.170	0.221	0.381	-0.011	0.076	0.219	0.515	1.000	-0.104	-0.025	0.140	0.029	0.124	0.493	0.030	0.035	0.029	0.033
CumGPALast	0.165	-0.078	-0.166	0.006	-0.341	-0.286	-0.049	-0.104	1.000	-0.342	0.062	0.196	0.037	0.092	0.056	0.065	0.045	0.163
PercentageOfAbsence	-0.054	0.081	0.027	0.051	0.260	0.173	-0.045	-0.025	-0.342	1.000	0.049	0.158	0.033	0.043	0.026	0.049	0.022	0.272
Full	0.050	0.901	0.083	0.372	0.216	0.029	0.104	0.140	0.062	0.049	1.000	0.112	0.070	0.108	0.095	0.025	0.019	0.134
Dev	0.007	0.125	0.021	0.059	0.159	0.090	0.048	0.029	0.196	0.158	0.112	1.000	0.059	0.077	0.062	0.011	0.020	0.132
TermCode	0.447	0.065	0.042	0.050	0.044	0.032	0.102	0.124	0.037	0.033	0.070	0.059	1.000	0.122	0.036	0.049	0.051	0.085
MajorChangedFromLast	0.113	0.159	0.126	0.034	0.057	0.084	0.108	0.493	0.092	0.043	0.108	0.077	0.122	1.000	0.011	0.000	0.004	0.041
Ethnicity	0.066	0.049	0.079	0.022	0.034	0.015	0.023	0.030	0.056	0.026	0.095	0.062	0.036	0.011	1.000	0.075	0.697	0.044
Gender	0.066	0.054	0.083	0.027	0.017	0.010	0.072	0.035	0.065	0.049	0.025	0.011	0.049	0.000	0.075	1.000	0.020	0.006
IsHispanic	0.042	0.026	0.085	0.000	0.032	0.006	0.040	0.029	0.045	0.022	0.019	0.020	0.051	0.004	0.697	0.020	1.000	0.000
Target	0.017	0.161	0.016	0.155	0.156	0.122	0.046	0.033	0.163	0.272	0.134	0.132	0.085	0.041	0.044	0.006	0.000	1.000

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows
Last rows

	StudentID	Attempted	Full	Age	Dev	Internet	PercentageOfRepeats	PercentageOfHistDrop	TermCode	MajorChangedFromLast	NumberOfMajors	NumberOfUniqueMajors	CumGPALast	PercentageOfAbsence	Ethnicity	Gender	IsHispanic	Target
0	101001184	16.0	1	27.0	0	0	0.250000	0.000000	B17C	0	3	1	2.6000	0.020000	White, Non-Hispanic	Female	No	0
1	101001184	10.0	0	28.0	1	0	0.000000	0.000000	B18Q	1	5	2	2.4286	0.230769	White, Non-Hispanic	Female	No	0
2	102001082	17.0	1	20.0	0	2	0.285714	0.047619	B17C	0	4	1	3.8478	0.090909	White, Non-Hispanic	Female	No	1
3	102002426	14.0	1	23.0	0	2	0.000000	0.111111	B17C	1	9	2	2.9057	0.236842	Hispanic	Female	Yes	0
4	102002426	15.0	1	25.0	0	5	0.000000	0.095238	B19Q	0	13	3	2.8833	0.000000	Hispanic	Female	Yes	0
5	102002757	9.0	0	30.0	0	0	1.000000	0.083333	B17C	0	11	1	3.3676	0.044444	American Indian or Alaskan Native	Female	No	0
6	102002757	8.0	0	30.0	0	0	0.000000	0.076923	B17Q	0	12	1	3.2917	0.088235	American Indian or Alaskan Native	Female	No	0
7	102002757	19.0	1	31.0	0	0	0.000000	0.073171	B18C	1	13	2	3.2917	0.078431	American Indian or Alaskan Native	Female	No	0
8	102002757	6.0	0	31.0	0	0	0.000000	0.062500	B18Q	1	15	2	3.2447	0.111111	American Indian or Alaskan Native	Female	No	0
9	102007458	13.0	0	22.0	0	0	0.000000	0.000000	B17C	0	4	1	0.9474	0.281250	Hispanic	Male	Yes	1

	StudentID	Attempted	Full	Age	Dev	Internet	TermCode	NumberOfMajors	NumberOfUniqueMajors	CumGPALast	PercentageOfAbsence	Ethnicity	Gender	IsHispanic	Target
24068	10112752012	12.0	1	19.0	0	0	B23C	2	1	2.75	0.056604	White, Non-Hispanic	Male	unknown	0
24069	10112752013	9.0	0	36.0	0	1	B23C	2	1	4.00	0.038462	White, Non-Hispanic	Male	unknown	0
24070	10112752014	12.0	1	42.0	0	1	B23C	2	1	4.00	0.052632	White, Non-Hispanic	Male	No	0
24071	10112752031	9.0	0	24.0	2	0	B23C	2	1	2.80	0.239130	Hispanic	Male	Yes	0
24072	10112752070	20.0	1	20.0	0	0	B23C	2	1	3.80	0.000000	White, Non-Hispanic	Male	No	0
24073	10112752072	20.0	1	33.0	0	0	B23C	3	1	4.00	0.000000	White, Non-Hispanic	Male	No	0
24074	10112752077	20.0	1	25.0	0	0	B23C	2	1	4.00	0.000000	American Indian or Alaskan Native	Male	No	0
24075	10112752099	20.0	1	29.0	0	0	B23C	2	1	3.80	0.000000	White, Non-Hispanic	Male	No	0
24076	10112752138	20.0	1	20.0	0	0	B23C	2	1	4.00	0.000000	White, Non-Hispanic	Male	unknown	0
24077	10112752140	9.0	0	24.0	1	0	B23C	2	1	4.00	0.294118	White, Non-Hispanic	Male	unknown	1

Overview

Variables

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Uppercase Letter

Most occurring scripts

Most frequent character per script

Common

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Space Separator

Dash Punctuation

Other Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter